package com.hna.eking.AirGisPlt.MybatisImp;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.hna.eking.AirGisPlt.Mapper.MapStarInfoMapper;;
public interface MapStarInfo {
		@Select("select * from MapStarInfo where AirportCode = #{AirportCode}")
		public List<MapStarInfoMapper> getByAirportCode(String AirportCode);
		
		@Insert("insert into MapStarInfo values(#{AirportCode}, #{PubDate}, #{IndCode}, #{AirportName}, #{Country}, #{City}, " + 
				"#{TransLevSet}, #{TransALT}, #{ATIS}, #{AptElev}, #{TransLev}, #{MaxSpeed}, #{FLConv}, #{FTConv}, #{ArrvCode}, #{Runway})")
		public int InsertMapStarInfo(MapStarInfoMapper MapStarInfo);	
		
		@Delete("delete from MapStarInfo where AirportCode = #{AirportCode}")
		public int DeleteMapStarInfo(String AirportCode);
		
		@Update("update MapStarInfo set PubDate = #{PubDate}, IndCode = #{IndCode}, TransLevSet = #{TransLevSet}," + 
				"AirportName = #{AirportName}, Country = #{Country}, City = #{City}" + 
				"TransALT = #{TransALT}, ATIS = #{ATIS}, AptElev = #{AptElev}, TransLev = #{TransLev}, MaxSpeed = #{MaxSpeed}, " + 
				"FLConv = #{FLConv}, FTConv = #{FTConv}, ArrvCode = #{ArrvCode}, Runway = #{Runway}" +
				"where AirportCode = #{AirportCode}")
		public int UpdatebyAirlineCode(String AirportCode);
}
